Tabela ContractServiceType

Definicja tabeli ContractServiceType

Name

ContractServiceType

Code

ContractServiceType

Comment

 


Lista kolumn tabeli ContractServiceType

Name

Code

ContractServiceTypeID

ContractServiceTypeID

Active

Active

Code

Code

Description

Description

FullName

FullName

ShortName

ShortName


Kolumna ContractServiceTypeID tabeli ContractServiceType

Definicja kolumny ContractServiceTypeID tabeli ContractServiceType

Name

ContractServiceTypeID

Code

ContractServiceTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli ContractServiceType

Definicja kolumny Active tabeli ContractServiceType

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Code tabeli ContractServiceType

Definicja kolumny Code tabeli ContractServiceType

Name

Code

Code

Code

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Description tabeli ContractServiceType

Definicja kolumny Description tabeli ContractServiceType

Name

Description

Code

Description

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna FullName tabeli ContractServiceType

Definicja kolumny FullName tabeli ContractServiceType

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ShortName tabeli ContractServiceType

Definicja kolumny ShortName tabeli ContractServiceType

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Lista kluczy tabeli ContractServiceType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ContractServiceType

Definicja klucza Identifier_1 tabeli ContractServiceType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment